﻿using System;
namespace fanli.Model
{
	/// <summary>
	/// 配置字段实体类：fanli_config 。
	/// </summary>
	[Serializable]
	public class fanli_config
	{
		public fanli_config()
		{}

		#region Model
		private int _id; //id
		private string _title; //名称
		private string _content; //内容
		private string _about; //备注


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 名称
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 备注
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
		#endregion Model

		#region txt document
		/*
配置字段,config
id,名称,内容,备注
id,title,content,about
i,c100,c500,c200

--------------------------
-- 创建表[配置字段]开始: 
-- alter table  [fanli_config] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='fanli_config') drop table fanli_config
  CREATE TABLE [fanli_config] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [title] [varchar] (100),
	 [content] [varchar] (500),
	 [about] [varchar] (200)
  )

 exec sp_addextendedproperty N'MS_Description',N'配置字段 ',N'user',N'dbo',N'table',N'fanli_config', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'fanli_config',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'名称',N'user',N'dbo',N'table',N'fanli_config',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'fanli_config',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'备注',N'user',N'dbo',N'table',N'fanli_config',N'column',N'about'

-- 创建表[配置字段]结束。 
--------------------------

		*/
		#endregion document
	}
}

